﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsContract" targetNamespace="http://tempuri.org/dsContract.xsd" xmlns:mstns="http://tempuri.org/dsContract.xsd" xmlns="http://tempuri.org/dsContract.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Settings" AppSettingsPropertyName="CrewManagmentConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="CrewManagmentConnectionString (Settings)" ParameterPrefix="@" PropertyReference="ApplicationSettings.QLTV.Properties.Settings.GlobalReference.Default.CrewManagmentConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblContractTableAdapter" GeneratorDataComponentClassName="tblContractTableAdapter" Name="tblContract" UserDataComponentName="tblContractTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblContract" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="false" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [tblContract] WHERE (([nContractId] = @Original_nContractId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContractId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContractId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [tblContract] ([nCrewId], [nEmployerId], [nVesselId], [dContractDate], [PeriodOfEmployment]) VALUES (@nCrewId, @nEmployerId, @nVesselId, @dContractDate, @PeriodOfEmployment)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEmployerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEmployerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dContractDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dContractDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PeriodOfEmployment" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PeriodOfEmployment" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        nContractId, nCrewId, nEmployerId, nVesselId, dContractDate, PeriodOfEmployment
FROM            tblContract</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [tblContract] SET [nCrewId] = @nCrewId, [nEmployerId] = @nEmployerId, [nVesselId] = @nVesselId, [dContractDate] = @dContractDate, [PeriodOfEmployment] = @PeriodOfEmployment WHERE (([nContractId] = @Original_nContractId))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEmployerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEmployerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dContractDate" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dContractDate" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@PeriodOfEmployment" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="PeriodOfEmployment" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nContractId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nContractId" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nContractId" DataSetColumn="nContractId" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="nEmployerId" DataSetColumn="nEmployerId" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="dContractDate" DataSetColumn="dContractDate" />
              <Mapping SourceColumn="PeriodOfEmployment" DataSetColumn="PeriodOfEmployment" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblContract" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByCrewID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCrewID" GeneratorSourceName="FillByCrewID" GetMethodModifier="Public" GetMethodName="GetDataByCrewID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCrewID" UserSourceName="FillByCrewID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT PeriodOfEmployment, dContractDate, nContractId, nCrewId, nEmployerId, nVesselId FROM tblContract WHERE (nCrewId = @crewID)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="crewID" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblContract" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@crewID" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblContract" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="FillByID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByID" GeneratorSourceName="FillByID" GetMethodModifier="Public" GetMethodName="GetDataByID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByID" UserSourceName="FillByID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT PeriodOfEmployment, dContractDate, nContractId, nCrewId, nEmployerId, nVesselId FROM tblContract WHERE (nContractId = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="id" ColumnName="nContractId" DataSourceName="CrewManagment.dbo.tblContract" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nContractId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblCrewTableAdapter" GeneratorDataComponentClassName="tblCrewTableAdapter" Name="tblCrew" UserDataComponentName="tblCrewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblCrew" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblCrew] WHERE (([nCrewId] = @Original_nCrewId) AND ((@IsNull_nRankID = 1 AND [nRankID] IS NULL) OR ([nRankID] = @Original_nRankID)) AND ((@IsNull_iCrewType = 1 AND [iCrewType] IS NULL) OR ([iCrewType] = @Original_iCrewType)) AND ((@IsNull_cFamilyName = 1 AND [cFamilyName] IS NULL) OR ([cFamilyName] = @Original_cFamilyName)) AND ((@IsNull_cMiddleName = 1 AND [cMiddleName] IS NULL) OR ([cMiddleName] = @Original_cMiddleName)) AND ((@IsNull_cFirstName = 1 AND [cFirstName] IS NULL) OR ([cFirstName] = @Original_cFirstName)) AND ((@IsNull_cCMT = 1 AND [cCMT] IS NULL) OR ([cCMT] = @Original_cCMT)) AND ((@IsNull_dNgayCap = 1 AND [dNgayCap] IS NULL) OR ([dNgayCap] = @Original_dNgayCap)) AND ((@IsNull_nNoiCap = 1 AND [nNoiCap] IS NULL) OR ([nNoiCap] = @Original_nNoiCap)) AND ((@IsNull_cAlias = 1 AND [cAlias] IS NULL) OR ([cAlias] = @Original_cAlias)) AND ((@IsNull_dDateOfBirth = 1 AND [dDateOfBirth] IS NULL) OR ([dDateOfBirth] = @Original_dDateOfBirth)) AND ((@IsNull_cAddress = 1 AND [cAddress] IS NULL) OR ([cAddress] = @Original_cAddress)) AND ((@IsNull_cPlaceOfBirth = 1 AND [cPlaceOfBirth] IS NULL) OR ([cPlaceOfBirth] = @Original_cPlaceOfBirth)) AND ((@IsNull_cHomeNo = 1 AND [cHomeNo] IS NULL) OR ([cHomeNo] = @Original_cHomeNo)) AND ((@IsNull_cHandNo = 1 AND [cHandNo] IS NULL) OR ([cHandNo] = @Original_cHandNo)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cSex = 1 AND [cSex] IS NULL) OR ([cSex] = @Original_cSex)) AND ((@IsNull_cMaritalStatus = 1 AND [cMaritalStatus] IS NULL) OR ([cMaritalStatus] = @Original_cMaritalStatus)) AND ((@IsNull_cNationality = 1 AND [cNationality] IS NULL) OR ([cNationality] = @Original_cNationality)) AND ((@IsNull_cContactPerson = 1 AND [cContactPerson] IS NULL) OR ([cContactPerson] = @Original_cContactPerson)) AND ((@IsNull_cContactPersonAddress = 1 AND [cContactPersonAddress] IS NULL) OR ([cContactPersonAddress] = @Original_cContactPersonAddress)) AND ((@IsNull_cContactPersonNo = 1 AND [cContactPersonNo] IS NULL) OR ([cContactPersonNo] = @Original_cContactPersonNo)) AND ((@IsNull_cContactRelation = 1 AND [cContactRelation] IS NULL) OR ([cContactRelation] = @Original_cContactRelation)) AND ((@IsNull_cContactEmail = 1 AND [cContactEmail] IS NULL) OR ([cContactEmail] = @Original_cContactEmail)) AND ((@IsNull_fHeight = 1 AND [fHeight] IS NULL) OR ([fHeight] = @Original_fHeight)) AND ((@IsNull_fWeight = 1 AND [fWeight] IS NULL) OR ([fWeight] = @Original_fWeight)) AND ((@IsNull_cBloodGroup = 1 AND [cBloodGroup] IS NULL) OR ([cBloodGroup] = @Original_cBloodGroup)) AND ((@IsNull_fShoeSizeVN = 1 AND [fShoeSizeVN] IS NULL) OR ([fShoeSizeVN] = @Original_fShoeSizeVN)) AND ((@IsNull_fShoeSizeJP = 1 AND [fShoeSizeJP] IS NULL) OR ([fShoeSizeJP] = @Original_fShoeSizeJP)) AND ((@IsNull_fOverallSizeVN = 1 AND [fOverallSizeVN] IS NULL) OR ([fOverallSizeVN] = @Original_fOverallSizeVN)) AND ((@IsNull_cOverallSizeJP = 1 AND [cOverallSizeJP] IS NULL) OR ([cOverallSizeJP] = @Original_cOverallSizeJP)) AND ((@IsNull_bDeleted = 1 AND [bDeleted] IS NULL) OR ([bDeleted] = @Original_bDeleted)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFamilyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cCMT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNgayCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nNoiCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPlaceOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHomeNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHandNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cSex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMaritalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactRelation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fWeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cBloodGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fOverallSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cOverallSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblCrew] ([nCrewId], [nRankID], [iCrewType], [bImage], [cFamilyName], [cMiddleName], [cFirstName], [cCMT], [dNgayCap], [nNoiCap], [cAlias], [dDateOfBirth], [cAddress], [cPlaceOfBirth], [cHomeNo], [cHandNo], [cEmail], [cSex], [cMaritalStatus], [cNationality], [cContactPerson], [cContactPersonAddress], [cContactPersonNo], [cContactRelation], [cContactEmail], [fHeight], [fWeight], [cBloodGroup], [fShoeSizeVN], [fShoeSizeJP], [fOverallSizeVN], [cOverallSizeJP], [bDeleted]) VALUES (@nCrewId, @nRankID, @iCrewType, @bImage, @cFamilyName, @cMiddleName, @cFirstName, @cCMT, @dNgayCap, @nNoiCap, @cAlias, @dDateOfBirth, @cAddress, @cPlaceOfBirth, @cHomeNo, @cHandNo, @cEmail, @cSex, @cMaritalStatus, @cNationality, @cContactPerson, @cContactPersonAddress, @cContactPersonNo, @cContactRelation, @cContactEmail, @fHeight, @fWeight, @cBloodGroup, @fShoeSizeVN, @fShoeSizeJP, @fOverallSizeVN, @cOverallSizeJP, @bDeleted);
SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted FROM tblCrew WHERE (nCrewId = @nCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="bImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cCMT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted FROM dbo.tblCrew</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblCrew] SET [nCrewId] = @nCrewId, [nRankID] = @nRankID, [iCrewType] = @iCrewType, [bImage] = @bImage, [cFamilyName] = @cFamilyName, [cMiddleName] = @cMiddleName, [cFirstName] = @cFirstName, [cCMT] = @cCMT, [dNgayCap] = @dNgayCap, [nNoiCap] = @nNoiCap, [cAlias] = @cAlias, [dDateOfBirth] = @dDateOfBirth, [cAddress] = @cAddress, [cPlaceOfBirth] = @cPlaceOfBirth, [cHomeNo] = @cHomeNo, [cHandNo] = @cHandNo, [cEmail] = @cEmail, [cSex] = @cSex, [cMaritalStatus] = @cMaritalStatus, [cNationality] = @cNationality, [cContactPerson] = @cContactPerson, [cContactPersonAddress] = @cContactPersonAddress, [cContactPersonNo] = @cContactPersonNo, [cContactRelation] = @cContactRelation, [cContactEmail] = @cContactEmail, [fHeight] = @fHeight, [fWeight] = @fWeight, [cBloodGroup] = @cBloodGroup, [fShoeSizeVN] = @fShoeSizeVN, [fShoeSizeJP] = @fShoeSizeJP, [fOverallSizeVN] = @fOverallSizeVN, [cOverallSizeJP] = @cOverallSizeJP, [bDeleted] = @bDeleted WHERE (([nCrewId] = @Original_nCrewId) AND ((@IsNull_nRankID = 1 AND [nRankID] IS NULL) OR ([nRankID] = @Original_nRankID)) AND ((@IsNull_iCrewType = 1 AND [iCrewType] IS NULL) OR ([iCrewType] = @Original_iCrewType)) AND ((@IsNull_cFamilyName = 1 AND [cFamilyName] IS NULL) OR ([cFamilyName] = @Original_cFamilyName)) AND ((@IsNull_cMiddleName = 1 AND [cMiddleName] IS NULL) OR ([cMiddleName] = @Original_cMiddleName)) AND ((@IsNull_cFirstName = 1 AND [cFirstName] IS NULL) OR ([cFirstName] = @Original_cFirstName)) AND ((@IsNull_cCMT = 1 AND [cCMT] IS NULL) OR ([cCMT] = @Original_cCMT)) AND ((@IsNull_dNgayCap = 1 AND [dNgayCap] IS NULL) OR ([dNgayCap] = @Original_dNgayCap)) AND ((@IsNull_nNoiCap = 1 AND [nNoiCap] IS NULL) OR ([nNoiCap] = @Original_nNoiCap)) AND ((@IsNull_cAlias = 1 AND [cAlias] IS NULL) OR ([cAlias] = @Original_cAlias)) AND ((@IsNull_dDateOfBirth = 1 AND [dDateOfBirth] IS NULL) OR ([dDateOfBirth] = @Original_dDateOfBirth)) AND ((@IsNull_cAddress = 1 AND [cAddress] IS NULL) OR ([cAddress] = @Original_cAddress)) AND ((@IsNull_cPlaceOfBirth = 1 AND [cPlaceOfBirth] IS NULL) OR ([cPlaceOfBirth] = @Original_cPlaceOfBirth)) AND ((@IsNull_cHomeNo = 1 AND [cHomeNo] IS NULL) OR ([cHomeNo] = @Original_cHomeNo)) AND ((@IsNull_cHandNo = 1 AND [cHandNo] IS NULL) OR ([cHandNo] = @Original_cHandNo)) AND ((@IsNull_cEmail = 1 AND [cEmail] IS NULL) OR ([cEmail] = @Original_cEmail)) AND ((@IsNull_cSex = 1 AND [cSex] IS NULL) OR ([cSex] = @Original_cSex)) AND ((@IsNull_cMaritalStatus = 1 AND [cMaritalStatus] IS NULL) OR ([cMaritalStatus] = @Original_cMaritalStatus)) AND ((@IsNull_cNationality = 1 AND [cNationality] IS NULL) OR ([cNationality] = @Original_cNationality)) AND ((@IsNull_cContactPerson = 1 AND [cContactPerson] IS NULL) OR ([cContactPerson] = @Original_cContactPerson)) AND ((@IsNull_cContactPersonAddress = 1 AND [cContactPersonAddress] IS NULL) OR ([cContactPersonAddress] = @Original_cContactPersonAddress)) AND ((@IsNull_cContactPersonNo = 1 AND [cContactPersonNo] IS NULL) OR ([cContactPersonNo] = @Original_cContactPersonNo)) AND ((@IsNull_cContactRelation = 1 AND [cContactRelation] IS NULL) OR ([cContactRelation] = @Original_cContactRelation)) AND ((@IsNull_cContactEmail = 1 AND [cContactEmail] IS NULL) OR ([cContactEmail] = @Original_cContactEmail)) AND ((@IsNull_fHeight = 1 AND [fHeight] IS NULL) OR ([fHeight] = @Original_fHeight)) AND ((@IsNull_fWeight = 1 AND [fWeight] IS NULL) OR ([fWeight] = @Original_fWeight)) AND ((@IsNull_cBloodGroup = 1 AND [cBloodGroup] IS NULL) OR ([cBloodGroup] = @Original_cBloodGroup)) AND ((@IsNull_fShoeSizeVN = 1 AND [fShoeSizeVN] IS NULL) OR ([fShoeSizeVN] = @Original_fShoeSizeVN)) AND ((@IsNull_fShoeSizeJP = 1 AND [fShoeSizeJP] IS NULL) OR ([fShoeSizeJP] = @Original_fShoeSizeJP)) AND ((@IsNull_fOverallSizeVN = 1 AND [fOverallSizeVN] IS NULL) OR ([fOverallSizeVN] = @Original_fOverallSizeVN)) AND ((@IsNull_cOverallSizeJP = 1 AND [cOverallSizeJP] IS NULL) OR ([cOverallSizeJP] = @Original_cOverallSizeJP)) AND ((@IsNull_bDeleted = 1 AND [bDeleted] IS NULL) OR ([bDeleted] = @Original_bDeleted)));
SELECT nCrewId, nRankID, iCrewType, bImage, cFamilyName, cMiddleName, cFirstName, cCMT, dNgayCap, nNoiCap, cAlias, dDateOfBirth, cAddress, cPlaceOfBirth, cHomeNo, cHandNo, cEmail, cSex, cMaritalStatus, cNationality, cContactPerson, cContactPersonAddress, cContactPersonNo, cContactRelation, cContactEmail, fHeight, fWeight, cBloodGroup, fShoeSizeVN, fShoeSizeJP, fOverallSizeVN, cOverallSizeJP, bDeleted FROM tblCrew WHERE (nCrewId = @nCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Binary" Direction="Input" ParameterName="@bImage" Precision="0" ProviderType="Image" Scale="0" Size="0" SourceColumn="bImage" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cCMT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nRankID" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nRankID" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_iCrewType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="iCrewType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFamilyName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFamilyName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFamilyName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMiddleName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cMiddleName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cMiddleName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cFirstName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cFirstName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cFirstName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cCMT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cCMT" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cCMT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dNgayCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dNgayCap" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dNgayCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nNoiCap" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_nNoiCap" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="nNoiCap" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAlias" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAlias" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAlias" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfBirth" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPlaceOfBirth" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPlaceOfBirth" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPlaceOfBirth" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHomeNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHomeNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHomeNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cHandNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cHandNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cHandNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cSex" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cSex" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cSex" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cMaritalStatus" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cMaritalStatus" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cMaritalStatus" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cNationality" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cNationality" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cNationality" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPerson" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPerson" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPerson" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonAddress" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactPersonAddress" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactPersonAddress" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactPersonNo" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactPersonNo" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactPersonNo" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactRelation" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cContactRelation" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cContactRelation" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cContactEmail" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cContactEmail" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cContactEmail" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fWeight" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fWeight" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fWeight" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cBloodGroup" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cBloodGroup" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cBloodGroup" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fShoeSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fShoeSizeJP" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fShoeSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fOverallSizeVN" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fOverallSizeVN" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fOverallSizeVN" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cOverallSizeJP" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cOverallSizeJP" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cOverallSizeJP" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_bDeleted" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Boolean" Direction="Input" ParameterName="@Original_bDeleted" Precision="0" ProviderType="Bit" Scale="0" Size="0" SourceColumn="bDeleted" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="nRankID" DataSetColumn="nRankID" />
              <Mapping SourceColumn="iCrewType" DataSetColumn="iCrewType" />
              <Mapping SourceColumn="bImage" DataSetColumn="bImage" />
              <Mapping SourceColumn="cFamilyName" DataSetColumn="cFamilyName" />
              <Mapping SourceColumn="cMiddleName" DataSetColumn="cMiddleName" />
              <Mapping SourceColumn="cFirstName" DataSetColumn="cFirstName" />
              <Mapping SourceColumn="cCMT" DataSetColumn="cCMT" />
              <Mapping SourceColumn="dNgayCap" DataSetColumn="dNgayCap" />
              <Mapping SourceColumn="nNoiCap" DataSetColumn="nNoiCap" />
              <Mapping SourceColumn="cAlias" DataSetColumn="cAlias" />
              <Mapping SourceColumn="dDateOfBirth" DataSetColumn="dDateOfBirth" />
              <Mapping SourceColumn="cAddress" DataSetColumn="cAddress" />
              <Mapping SourceColumn="cPlaceOfBirth" DataSetColumn="cPlaceOfBirth" />
              <Mapping SourceColumn="cHomeNo" DataSetColumn="cHomeNo" />
              <Mapping SourceColumn="cHandNo" DataSetColumn="cHandNo" />
              <Mapping SourceColumn="cEmail" DataSetColumn="cEmail" />
              <Mapping SourceColumn="cSex" DataSetColumn="cSex" />
              <Mapping SourceColumn="cMaritalStatus" DataSetColumn="cMaritalStatus" />
              <Mapping SourceColumn="cNationality" DataSetColumn="cNationality" />
              <Mapping SourceColumn="cContactPerson" DataSetColumn="cContactPerson" />
              <Mapping SourceColumn="cContactPersonAddress" DataSetColumn="cContactPersonAddress" />
              <Mapping SourceColumn="cContactPersonNo" DataSetColumn="cContactPersonNo" />
              <Mapping SourceColumn="cContactRelation" DataSetColumn="cContactRelation" />
              <Mapping SourceColumn="cContactEmail" DataSetColumn="cContactEmail" />
              <Mapping SourceColumn="fHeight" DataSetColumn="fHeight" />
              <Mapping SourceColumn="fWeight" DataSetColumn="fWeight" />
              <Mapping SourceColumn="cBloodGroup" DataSetColumn="cBloodGroup" />
              <Mapping SourceColumn="fShoeSizeVN" DataSetColumn="fShoeSizeVN" />
              <Mapping SourceColumn="fShoeSizeJP" DataSetColumn="fShoeSizeJP" />
              <Mapping SourceColumn="fOverallSizeVN" DataSetColumn="fOverallSizeVN" />
              <Mapping SourceColumn="cOverallSizeJP" DataSetColumn="cOverallSizeJP" />
              <Mapping SourceColumn="bDeleted" DataSetColumn="bDeleted" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblVesselTableAdapter" GeneratorDataComponentClassName="tblVesselTableAdapter" Name="tblVessel" UserDataComponentName="tblVesselTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblVessel" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblVessel] WHERE (([nVesselId] = @Original_nVesselId) AND ((@IsNull_nEngineType = 1 AND [nEngineType] IS NULL) OR ([nEngineType] = @Original_nEngineType)) AND ((@IsNull_nEngineMaker = 1 AND [nEngineMaker] IS NULL) OR ([nEngineMaker] = @Original_nEngineMaker)) AND ((@IsNull_fHorsePower = 1 AND [fHorsePower] IS NULL) OR ([fHorsePower] = @Original_fHorsePower)) AND ((@IsNull_cVesselName = 1 AND [cVesselName] IS NULL) OR ([cVesselName] = @Original_cVesselName)) AND ((@IsNull_cShortName = 1 AND [cShortName] IS NULL) OR ([cShortName] = @Original_cShortName)) AND ((@IsNull_nGroupId = 1 AND [nGroupId] IS NULL) OR ([nGroupId] = @Original_nGroupId)) AND ((@IsNull_nFlagId = 1 AND [nFlagId] IS NULL) OR ([nFlagId] = @Original_nFlagId)) AND ((@IsNull_nVesselTypeId = 1 AND [nVesselTypeId] IS NULL) OR ([nVesselTypeId] = @Original_nVesselTypeId)) AND ((@IsNull_fGRT = 1 AND [fGRT] IS NULL) OR ([fGRT] = @Original_fGRT)) AND ((@IsNull_cImoNumber = 1 AND [cImoNumber] IS NULL) OR ([cImoNumber] = @Original_cImoNumber)) AND ((@IsNull_cPortOfRegistry = 1 AND [cPortOfRegistry] IS NULL) OR ([cPortOfRegistry] = @Original_cPortOfRegistry)) AND ((@IsNull_dYearBuilt = 1 AND [dYearBuilt] IS NULL) OR ([dYearBuilt] = @Original_dYearBuilt)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHorsePower" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fGRT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cImoNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPortOfRegistry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dYearBuilt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblVessel] ([nEngineType], [nEngineMaker], [fHorsePower], [cVesselName], [cShortName], [nGroupId], [nFlagId], [nVesselTypeId], [fGRT], [cTradeArea], [cImoNumber], [cPortOfRegistry], [dYearBuilt]) VALUES (@nEngineType, @nEngineMaker, @fHorsePower, @cVesselName, @cShortName, @nGroupId, @nFlagId, @nVesselTypeId, @fGRT, @cTradeArea, @cImoNumber, @cPortOfRegistry, @dYearBuilt);
SELECT nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, cImoNumber, cPortOfRegistry, dYearBuilt FROM tblVessel WHERE (nVesselId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTradeArea" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTradeArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, cImoNumber, cPortOfRegistry, dYearBuilt FROM dbo.tblVessel</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblVessel] SET [nEngineType] = @nEngineType, [nEngineMaker] = @nEngineMaker, [fHorsePower] = @fHorsePower, [cVesselName] = @cVesselName, [cShortName] = @cShortName, [nGroupId] = @nGroupId, [nFlagId] = @nFlagId, [nVesselTypeId] = @nVesselTypeId, [fGRT] = @fGRT, [cTradeArea] = @cTradeArea, [cImoNumber] = @cImoNumber, [cPortOfRegistry] = @cPortOfRegistry, [dYearBuilt] = @dYearBuilt WHERE (([nVesselId] = @Original_nVesselId) AND ((@IsNull_nEngineType = 1 AND [nEngineType] IS NULL) OR ([nEngineType] = @Original_nEngineType)) AND ((@IsNull_nEngineMaker = 1 AND [nEngineMaker] IS NULL) OR ([nEngineMaker] = @Original_nEngineMaker)) AND ((@IsNull_fHorsePower = 1 AND [fHorsePower] IS NULL) OR ([fHorsePower] = @Original_fHorsePower)) AND ((@IsNull_cVesselName = 1 AND [cVesselName] IS NULL) OR ([cVesselName] = @Original_cVesselName)) AND ((@IsNull_cShortName = 1 AND [cShortName] IS NULL) OR ([cShortName] = @Original_cShortName)) AND ((@IsNull_nGroupId = 1 AND [nGroupId] IS NULL) OR ([nGroupId] = @Original_nGroupId)) AND ((@IsNull_nFlagId = 1 AND [nFlagId] IS NULL) OR ([nFlagId] = @Original_nFlagId)) AND ((@IsNull_nVesselTypeId = 1 AND [nVesselTypeId] IS NULL) OR ([nVesselTypeId] = @Original_nVesselTypeId)) AND ((@IsNull_fGRT = 1 AND [fGRT] IS NULL) OR ([fGRT] = @Original_fGRT)) AND ((@IsNull_cImoNumber = 1 AND [cImoNumber] IS NULL) OR ([cImoNumber] = @Original_cImoNumber)) AND ((@IsNull_cPortOfRegistry = 1 AND [cPortOfRegistry] IS NULL) OR ([cPortOfRegistry] = @Original_cPortOfRegistry)) AND ((@IsNull_dYearBuilt = 1 AND [dYearBuilt] IS NULL) OR ([dYearBuilt] = @Original_dYearBuilt)));
SELECT nVesselId, nEngineType, nEngineMaker, fHorsePower, cVesselName, cShortName, nGroupId, nFlagId, nVesselTypeId, fGRT, cTradeArea, cImoNumber, cPortOfRegistry, dYearBuilt FROM tblVessel WHERE (nVesselId = @nVesselId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cTradeArea" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cTradeArea" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineType" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineType" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEngineMaker" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEngineMaker" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fHorsePower" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fHorsePower" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fHorsePower" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cVesselName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cVesselName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cVesselName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cShortName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cShortName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cShortName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nGroupId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nGroupId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nFlagId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nFlagId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nVesselTypeId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nVesselTypeId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_fGRT" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Double" Direction="Input" ParameterName="@Original_fGRT" Precision="0" ProviderType="Float" Scale="0" Size="0" SourceColumn="fGRT" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cImoNumber" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_cImoNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cImoNumber" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cPortOfRegistry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cPortOfRegistry" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cPortOfRegistry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dYearBuilt" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dYearBuilt" Precision="0" ProviderType="SmallDateTime" Scale="0" Size="0" SourceColumn="dYearBuilt" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nVesselId" ColumnName="nVesselId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nVesselId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nVesselId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="nEngineType" DataSetColumn="nEngineType" />
              <Mapping SourceColumn="nEngineMaker" DataSetColumn="nEngineMaker" />
              <Mapping SourceColumn="fHorsePower" DataSetColumn="fHorsePower" />
              <Mapping SourceColumn="cVesselName" DataSetColumn="cVesselName" />
              <Mapping SourceColumn="cShortName" DataSetColumn="cShortName" />
              <Mapping SourceColumn="nGroupId" DataSetColumn="nGroupId" />
              <Mapping SourceColumn="nFlagId" DataSetColumn="nFlagId" />
              <Mapping SourceColumn="nVesselTypeId" DataSetColumn="nVesselTypeId" />
              <Mapping SourceColumn="fGRT" DataSetColumn="fGRT" />
              <Mapping SourceColumn="cTradeArea" DataSetColumn="cTradeArea" />
              <Mapping SourceColumn="cImoNumber" DataSetColumn="cImoNumber" />
              <Mapping SourceColumn="cPortOfRegistry" DataSetColumn="cPortOfRegistry" />
              <Mapping SourceColumn="dYearBuilt" DataSetColumn="dYearBuilt" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblImmigrationCrewTableAdapter" GeneratorDataComponentClassName="tblImmigrationCrewTableAdapter" Name="tblImmigrationCrew" UserDataComponentName="tblImmigrationCrewTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblImmigrationCrew" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblImmigrationCrew] WHERE (([nImmigrationCrewId] = @Original_nImmigrationCrewId) AND ((@IsNull_nImmigrationId = 1 AND [nImmigrationId] IS NULL) OR ([nImmigrationId] = @Original_nImmigrationId)) AND ((@IsNull_nCrewId = 1 AND [nCrewId] IS NULL) OR ([nCrewId] = @Original_nCrewId)) AND ((@IsNull_cIssuedBy = 1 AND [cIssuedBy] IS NULL) OR ([cIssuedBy] = @Original_cIssuedBy)) AND ((@IsNull_dDateOfIssued = 1 AND [dDateOfIssued] IS NULL) OR ([dDateOfIssued] = @Original_dDateOfIssued)) AND ((@IsNull_dDateOfExpiry = 1 AND [dDateOfExpiry] IS NULL) OR ([dDateOfExpiry] = @Original_dDateOfExpiry)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nImmigrationCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cIssuedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cIssuedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfIssued" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfIssued" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfExpiry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfExpiry" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfExpiry" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfExpiry" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblImmigrationCrew] ([nImmigrationId], [nCrewId], [cIssuedBy], [cNumber], [dDateOfIssued], [dDateOfExpiry]) VALUES (@nImmigrationId, @nCrewId, @cIssuedBy, @cNumber, @dDateOfIssued, @dDateOfExpiry);
SELECT nImmigrationCrewId, nImmigrationId, nCrewId, cIssuedBy, cNumber, dDateOfIssued, dDateOfExpiry FROM tblImmigrationCrew WHERE (nImmigrationCrewId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cIssuedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfIssued" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfExpiry" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nImmigrationCrewId, nImmigrationId, nCrewId, cIssuedBy, cNumber, dDateOfIssued, dDateOfExpiry FROM dbo.tblImmigrationCrew</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblImmigrationCrew] SET [nImmigrationId] = @nImmigrationId, [nCrewId] = @nCrewId, [cIssuedBy] = @cIssuedBy, [cNumber] = @cNumber, [dDateOfIssued] = @dDateOfIssued, [dDateOfExpiry] = @dDateOfExpiry WHERE (([nImmigrationCrewId] = @Original_nImmigrationCrewId) AND ((@IsNull_nImmigrationId = 1 AND [nImmigrationId] IS NULL) OR ([nImmigrationId] = @Original_nImmigrationId)) AND ((@IsNull_nCrewId = 1 AND [nCrewId] IS NULL) OR ([nCrewId] = @Original_nCrewId)) AND ((@IsNull_cIssuedBy = 1 AND [cIssuedBy] IS NULL) OR ([cIssuedBy] = @Original_cIssuedBy)) AND ((@IsNull_dDateOfIssued = 1 AND [dDateOfIssued] IS NULL) OR ([dDateOfIssued] = @Original_dDateOfIssued)) AND ((@IsNull_dDateOfExpiry = 1 AND [dDateOfExpiry] IS NULL) OR ([dDateOfExpiry] = @Original_dDateOfExpiry)));
SELECT nImmigrationCrewId, nImmigrationId, nCrewId, cIssuedBy, cNumber, dDateOfIssued, dDateOfExpiry FROM tblImmigrationCrew WHERE (nImmigrationCrewId = @nImmigrationCrewId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cIssuedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@cNumber" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="cNumber" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfIssued" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@dDateOfExpiry" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfExpiry" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nImmigrationCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_nCrewId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="AnsiString" Direction="Input" ParameterName="@Original_nCrewId" Precision="0" ProviderType="VarChar" Scale="0" Size="0" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cIssuedBy" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cIssuedBy" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cIssuedBy" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfIssued" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfIssued" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfIssued" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_dDateOfExpiry" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="dDateOfExpiry" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="DateTime" Direction="Input" ParameterName="@Original_dDateOfExpiry" Precision="0" ProviderType="DateTime" Scale="0" Size="0" SourceColumn="dDateOfExpiry" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nImmigrationCrewId" ColumnName="nImmigrationCrewId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nImmigrationCrewId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nImmigrationCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nImmigrationCrewId" DataSetColumn="nImmigrationCrewId" />
              <Mapping SourceColumn="nImmigrationId" DataSetColumn="nImmigrationId" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="cIssuedBy" DataSetColumn="cIssuedBy" />
              <Mapping SourceColumn="cNumber" DataSetColumn="cNumber" />
              <Mapping SourceColumn="dDateOfIssued" DataSetColumn="dDateOfIssued" />
              <Mapping SourceColumn="dDateOfExpiry" DataSetColumn="dDateOfExpiry" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblImmigrationCrew" DbObjectType="Table" GenerateShortCommands="true" GeneratorSourceName="PassportNumber" Modifier="Public" Name="PassportNumber" QueryType="Scalar" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataBy" UserSourceName="PassportNumber">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        cNumber
FROM            tblImmigrationCrew
WHERE        (nCrewId = @crewId) AND (nImmigrationId = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="crewId" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblImmigrationCrew" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@crewId" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="id" ColumnName="nImmigrationId" DataSourceName="CrewManagment.dbo.tblImmigrationCrew" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@id" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nImmigrationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblImmigrationDocTableAdapter" GeneratorDataComponentClassName="tblImmigrationDocTableAdapter" Name="tblImmigrationDoc" UserDataComponentName="tblImmigrationDocTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblImmigrationDoc" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblImmigrationDoc] WHERE (([nImmigrationId] = @Original_nImmigrationId) AND ((@IsNull_cDocName = 1 AND [cDocName] IS NULL) OR ([cDocName] = @Original_cDocName)) AND ((@IsNull_cDocDescription = 1 AND [cDocDescription] IS NULL) OR ([cDocDescription] = @Original_cDocDescription)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDocName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDocName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDocName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDocName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDocDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDocDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDocDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDocDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblImmigrationDoc] ([cDocName], [cDocDescription]) VALUES (@cDocName, @cDocDescription);
SELECT nImmigrationId, cDocName, cDocDescription FROM tblImmigrationDoc WHERE (nImmigrationId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDocName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDocName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDocDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDocDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nImmigrationId, cDocName, cDocDescription FROM dbo.tblImmigrationDoc</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblImmigrationDoc] SET [cDocName] = @cDocName, [cDocDescription] = @cDocDescription WHERE (([nImmigrationId] = @Original_nImmigrationId) AND ((@IsNull_cDocName = 1 AND [cDocName] IS NULL) OR ([cDocName] = @Original_cDocName)) AND ((@IsNull_cDocDescription = 1 AND [cDocDescription] IS NULL) OR ([cDocDescription] = @Original_cDocDescription)));
SELECT nImmigrationId, cDocName, cDocDescription FROM tblImmigrationDoc WHERE (nImmigrationId = @nImmigrationId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDocName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDocName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDocDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDocDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nImmigrationId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDocName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDocName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDocName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDocName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDocDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDocDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDocDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDocDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nImmigrationId" ColumnName="nImmigrationId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nImmigrationId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nImmigrationId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nImmigrationId" DataSetColumn="nImmigrationId" />
              <Mapping SourceColumn="cDocName" DataSetColumn="cDocName" />
              <Mapping SourceColumn="cDocDescription" DataSetColumn="cDocDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tblEmployerTableAdapter" GeneratorDataComponentClassName="tblEmployerTableAdapter" Name="tblEmployer" UserDataComponentName="tblEmployerTableAdapter">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectName="CrewManagment.dbo.tblEmployer" DbObjectType="Table" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <DeleteCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>DELETE FROM [dbo].[tblEmployer] WHERE (([nEmployerId] = @Original_nEmployerId) AND ((@IsNull_cEmployerName = 1 AND [cEmployerName] IS NULL) OR ([cEmployerName] = @Original_cEmployerName)) AND ((@IsNull_cAddresss = 1 AND [cAddresss] IS NULL) OR ([cAddresss] = @Original_cAddresss)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)))</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEmployerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEmployerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmployerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmployerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cEmployerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cEmployerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddresss" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddresss" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddresss" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddresss" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                    </Parameters>
                  </DbCommand>
                </DeleteCommand>
                <InsertCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>INSERT INTO [dbo].[tblEmployer] ([cEmployerName], [cAddresss], [cDescription]) VALUES (@cEmployerName, @cAddresss, @cDescription);
SELECT nEmployerId, cEmployerName, cAddresss, cDescription FROM tblEmployer WHERE (nEmployerId = SCOPE_IDENTITY())</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cEmployerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cEmployerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddresss" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddresss" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </InsertCommand>
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>SELECT nEmployerId, cEmployerName, cAddresss, cDescription FROM dbo.tblEmployer</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
                <UpdateCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="false">
                    <CommandText>UPDATE [dbo].[tblEmployer] SET [cEmployerName] = @cEmployerName, [cAddresss] = @cAddresss, [cDescription] = @cDescription WHERE (([nEmployerId] = @Original_nEmployerId) AND ((@IsNull_cEmployerName = 1 AND [cEmployerName] IS NULL) OR ([cEmployerName] = @Original_cEmployerName)) AND ((@IsNull_cAddresss = 1 AND [cAddresss] IS NULL) OR ([cAddresss] = @Original_cAddresss)) AND ((@IsNull_cDescription = 1 AND [cDescription] IS NULL) OR ([cDescription] = @Original_cDescription)));
SELECT nEmployerId, cEmployerName, cAddresss, cDescription FROM tblEmployer WHERE (nEmployerId = @nEmployerId)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cEmployerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cEmployerName" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cAddresss" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddresss" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Current" />
                      <Parameter AllowDbNull="false" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@Original_nEmployerId" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="nEmployerId" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cEmployerName" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cEmployerName" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cEmployerName" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cEmployerName" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cAddresss" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cAddresss" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cAddresss" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cAddresss" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="Int32" Direction="Input" ParameterName="@IsNull_cDescription" Precision="0" ProviderType="Int" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="true" SourceVersion="Original" />
                      <Parameter AllowDbNull="true" AutogeneratedName="" DataSourceName="" DbType="String" Direction="Input" ParameterName="@Original_cDescription" Precision="0" ProviderType="NVarChar" Scale="0" Size="0" SourceColumn="cDescription" SourceColumnNullMapping="false" SourceVersion="Original" />
                      <Parameter AllowDbNull="false" AutogeneratedName="nEmployerId" ColumnName="nEmployerId" DataSourceName="" DataTypeServer="int" DbType="Int32" Direction="Input" ParameterName="@nEmployerId" Precision="0" ProviderType="Int" Scale="0" Size="4" SourceColumn="nEmployerId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </UpdateCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nEmployerId" DataSetColumn="nEmployerId" />
              <Mapping SourceColumn="cEmployerName" DataSetColumn="cEmployerName" />
              <Mapping SourceColumn="cAddresss" DataSetColumn="cAddresss" />
              <Mapping SourceColumn="cDescription" DataSetColumn="cDescription" />
            </Mappings>
            <Sources />
          </TableAdapter>
          <TableAdapter BaseClass="System.ComponentModel.Component" DataAccessorModifier="AutoLayout, AnsiClass, Class, Public" DataAccessorName="tadContractlist" GeneratorDataComponentClassName="tadContractlist" Name="tblcontractList" UserDataComponentName="tadContractlist">
            <MainSource>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="Fill" GenerateMethods="Both" GenerateShortCommands="false" GeneratorGetMethodName="GetData" GeneratorSourceName="Fill" GetMethodModifier="Public" GetMethodName="GetData" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetData" UserSourceName="Fill">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblContract.nContractId, tblContract.nCrewId, tblContract.nEmployerId, tblContract.nVesselId, tblContract.dContractDate, tblContract.PeriodOfEmployment, 
                         tblAssignment.cStatus, tblRank.cRankName
FROM            tblAssignment INNER JOIN
                         tblCrew ON tblAssignment.nCrewid = tblCrew.nCrewId INNER JOIN
                         tblContract ON tblCrew.nCrewId = tblContract.nCrewId INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId
WHERE        (tblAssignment.isActive = 1)</CommandText>
                    <Parameters />
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </MainSource>
            <Mappings>
              <Mapping SourceColumn="nContractId" DataSetColumn="nContractId" />
              <Mapping SourceColumn="nCrewId" DataSetColumn="nCrewId" />
              <Mapping SourceColumn="nEmployerId" DataSetColumn="nEmployerId" />
              <Mapping SourceColumn="nVesselId" DataSetColumn="nVesselId" />
              <Mapping SourceColumn="dContractDate" DataSetColumn="dContractDate" />
              <Mapping SourceColumn="PeriodOfEmployment" DataSetColumn="PeriodOfEmployment" />
              <Mapping SourceColumn="cStatus" DataSetColumn="cStatus" />
              <Mapping SourceColumn="cRankName" DataSetColumn="cRankName" />
            </Mappings>
            <Sources>
              <DbSource ConnectionRef="CrewManagmentConnectionString (Settings)" DbObjectType="Unknown" FillMethodModifier="Public" FillMethodName="FillByCrewID" GenerateMethods="Both" GenerateShortCommands="true" GeneratorGetMethodName="GetDataByCrewID" GeneratorSourceName="FillByCrewID" GetMethodModifier="Public" GetMethodName="GetDataByCrewID" QueryType="Rowset" ScalarCallRetval="System.Object, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" UseOptimisticConcurrency="true" UserGetMethodName="GetDataByCrewID" UserSourceName="FillByCrewID">
                <SelectCommand>
                  <DbCommand CommandType="Text" ModifiedByUser="true">
                    <CommandText>SELECT        tblContract.nContractId, tblContract.nCrewId, tblContract.nEmployerId, tblContract.nVesselId, tblContract.dContractDate, tblContract.PeriodOfEmployment, 
                         tblAssignment.cStatus, tblRank.cRankName
FROM            tblAssignment INNER JOIN
                         tblCrew ON tblAssignment.nCrewid = tblCrew.nCrewId INNER JOIN
                         tblContract ON tblCrew.nCrewId = tblContract.nCrewId INNER JOIN
                         tblRank ON tblCrew.nRankID = tblRank.nRankId
WHERE        (tblAssignment.isActive = 1) AND (tblContract.nCrewId = @id)</CommandText>
                    <Parameters>
                      <Parameter AllowDbNull="true" AutogeneratedName="id" ColumnName="nCrewId" DataSourceName="CrewManagment.dbo.tblContract" DataTypeServer="varchar(50)" DbType="AnsiString" Direction="Input" ParameterName="@id" Precision="0" ProviderType="VarChar" Scale="0" Size="50" SourceColumn="nCrewId" SourceColumnNullMapping="false" SourceVersion="Current" />
                    </Parameters>
                  </DbCommand>
                </SelectCommand>
              </DbSource>
            </Sources>
          </TableAdapter>
        </Tables>
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsContract" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsContract" msprop:Generator_UserDSName="dsContract">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblContract" msprop:Generator_TableClassName="tblContractDataTable" msprop:Generator_TableVarName="tabletblContract" msprop:Generator_TablePropName="tblContract" msprop:Generator_RowDeletingName="tblContractRowDeleting" msprop:Generator_UserTableName="tblContract" msprop:Generator_RowChangingName="tblContractRowChanging" msprop:Generator_RowEvHandlerName="tblContractRowChangeEventHandler" msprop:Generator_RowDeletedName="tblContractRowDeleted" msprop:Generator_RowEvArgName="tblContractRowChangeEvent" msprop:Generator_RowChangedName="tblContractRowChanged" msprop:Generator_RowClassName="tblContractRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nContractId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnContractId" msprop:Generator_ColumnPropNameInRow="nContractId" msprop:Generator_ColumnPropNameInTable="nContractIdColumn" msprop:Generator_UserColumnName="nContractId" type="xs:int" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nEmployerId" msprop:Generator_ColumnVarNameInTable="columnnEmployerId" msprop:Generator_ColumnPropNameInRow="nEmployerId" msprop:Generator_ColumnPropNameInTable="nEmployerIdColumn" msprop:Generator_UserColumnName="nEmployerId" type="xs:int" default="1" minOccurs="0" />
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="dContractDate" msprop:Generator_ColumnVarNameInTable="columndContractDate" msprop:Generator_ColumnPropNameInRow="dContractDate" msprop:Generator_ColumnPropNameInTable="dContractDateColumn" msprop:Generator_UserColumnName="dContractDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PeriodOfEmployment" msprop:Generator_ColumnVarNameInTable="columnPeriodOfEmployment" msprop:Generator_ColumnPropNameInRow="PeriodOfEmployment" msprop:Generator_ColumnPropNameInTable="PeriodOfEmploymentColumn" msprop:Generator_UserColumnName="PeriodOfEmployment" type="xs:double" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblCrew" msprop:Generator_TableClassName="tblCrewDataTable" msprop:Generator_TableVarName="tabletblCrew" msprop:Generator_TablePropName="tblCrew" msprop:Generator_RowDeletingName="tblCrewRowDeleting" msprop:Generator_UserTableName="tblCrew" msprop:Generator_RowChangingName="tblCrewRowChanging" msprop:Generator_RowEvHandlerName="tblCrewRowChangeEventHandler" msprop:Generator_RowDeletedName="tblCrewRowDeleted" msprop:Generator_RowEvArgName="tblCrewRowChangeEvent" msprop:Generator_RowChangedName="tblCrewRowChanged" msprop:Generator_RowClassName="tblCrewRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nRankID" msprop:Generator_ColumnVarNameInTable="columnnRankID" msprop:Generator_ColumnPropNameInRow="nRankID" msprop:Generator_ColumnPropNameInTable="nRankIDColumn" msprop:Generator_UserColumnName="nRankID" type="xs:int" minOccurs="0" />
              <xs:element name="iCrewType" msprop:Generator_ColumnVarNameInTable="columniCrewType" msprop:Generator_ColumnPropNameInRow="iCrewType" msprop:Generator_ColumnPropNameInTable="iCrewTypeColumn" msprop:Generator_UserColumnName="iCrewType" type="xs:int" minOccurs="0" />
              <xs:element name="bImage" msprop:Generator_ColumnVarNameInTable="columnbImage" msprop:Generator_ColumnPropNameInRow="bImage" msprop:Generator_ColumnPropNameInTable="bImageColumn" msprop:Generator_UserColumnName="bImage" type="xs:base64Binary" minOccurs="0" />
              <xs:element name="cFamilyName" msprop:Generator_ColumnVarNameInTable="columncFamilyName" msprop:Generator_ColumnPropNameInRow="cFamilyName" msprop:Generator_ColumnPropNameInTable="cFamilyNameColumn" msprop:Generator_UserColumnName="cFamilyName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMiddleName" msprop:Generator_ColumnVarNameInTable="columncMiddleName" msprop:Generator_ColumnPropNameInRow="cMiddleName" msprop:Generator_ColumnPropNameInTable="cMiddleNameColumn" msprop:Generator_UserColumnName="cMiddleName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cFirstName" msprop:Generator_ColumnVarNameInTable="columncFirstName" msprop:Generator_ColumnPropNameInRow="cFirstName" msprop:Generator_ColumnPropNameInTable="cFirstNameColumn" msprop:Generator_UserColumnName="cFirstName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cCMT" msprop:Generator_ColumnVarNameInTable="columncCMT" msprop:Generator_ColumnPropNameInRow="cCMT" msprop:Generator_ColumnPropNameInTable="cCMTColumn" msprop:Generator_UserColumnName="cCMT" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dNgayCap" msprop:Generator_ColumnVarNameInTable="columndNgayCap" msprop:Generator_ColumnPropNameInRow="dNgayCap" msprop:Generator_ColumnPropNameInTable="dNgayCapColumn" msprop:Generator_UserColumnName="dNgayCap" type="xs:dateTime" minOccurs="0" />
              <xs:element name="nNoiCap" msprop:Generator_ColumnVarNameInTable="columnnNoiCap" msprop:Generator_ColumnPropNameInRow="nNoiCap" msprop:Generator_ColumnPropNameInTable="nNoiCapColumn" msprop:Generator_UserColumnName="nNoiCap" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cAlias" msprop:Generator_ColumnVarNameInTable="columncAlias" msprop:Generator_ColumnPropNameInRow="cAlias" msprop:Generator_ColumnPropNameInTable="cAliasColumn" msprop:Generator_UserColumnName="cAlias" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateOfBirth" msprop:Generator_ColumnVarNameInTable="columndDateOfBirth" msprop:Generator_ColumnPropNameInRow="dDateOfBirth" msprop:Generator_ColumnPropNameInTable="dDateOfBirthColumn" msprop:Generator_UserColumnName="dDateOfBirth" type="xs:dateTime" minOccurs="0" />
              <xs:element name="cAddress" msprop:Generator_ColumnVarNameInTable="columncAddress" msprop:Generator_ColumnPropNameInRow="cAddress" msprop:Generator_ColumnPropNameInTable="cAddressColumn" msprop:Generator_UserColumnName="cAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPlaceOfBirth" msprop:Generator_ColumnVarNameInTable="columncPlaceOfBirth" msprop:Generator_ColumnPropNameInRow="cPlaceOfBirth" msprop:Generator_ColumnPropNameInTable="cPlaceOfBirthColumn" msprop:Generator_UserColumnName="cPlaceOfBirth" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHomeNo" msprop:Generator_ColumnVarNameInTable="columncHomeNo" msprop:Generator_ColumnPropNameInRow="cHomeNo" msprop:Generator_ColumnPropNameInTable="cHomeNoColumn" msprop:Generator_UserColumnName="cHomeNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cHandNo" msprop:Generator_ColumnVarNameInTable="columncHandNo" msprop:Generator_ColumnPropNameInRow="cHandNo" msprop:Generator_ColumnPropNameInTable="cHandNoColumn" msprop:Generator_UserColumnName="cHandNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cEmail" msprop:Generator_ColumnVarNameInTable="columncEmail" msprop:Generator_ColumnPropNameInRow="cEmail" msprop:Generator_ColumnPropNameInTable="cEmailColumn" msprop:Generator_UserColumnName="cEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cSex" msprop:Generator_ColumnVarNameInTable="columncSex" msprop:Generator_ColumnPropNameInRow="cSex" msprop:Generator_ColumnPropNameInTable="cSexColumn" msprop:Generator_UserColumnName="cSex" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cMaritalStatus" msprop:Generator_ColumnVarNameInTable="columncMaritalStatus" msprop:Generator_ColumnPropNameInRow="cMaritalStatus" msprop:Generator_ColumnPropNameInTable="cMaritalStatusColumn" msprop:Generator_UserColumnName="cMaritalStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cNationality" msprop:Generator_ColumnVarNameInTable="columncNationality" msprop:Generator_ColumnPropNameInRow="cNationality" msprop:Generator_ColumnPropNameInTable="cNationalityColumn" msprop:Generator_UserColumnName="cNationality" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPerson" msprop:Generator_ColumnVarNameInTable="columncContactPerson" msprop:Generator_ColumnPropNameInRow="cContactPerson" msprop:Generator_ColumnPropNameInTable="cContactPersonColumn" msprop:Generator_UserColumnName="cContactPerson" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPersonAddress" msprop:Generator_ColumnVarNameInTable="columncContactPersonAddress" msprop:Generator_ColumnPropNameInRow="cContactPersonAddress" msprop:Generator_ColumnPropNameInTable="cContactPersonAddressColumn" msprop:Generator_UserColumnName="cContactPersonAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactPersonNo" msprop:Generator_ColumnVarNameInTable="columncContactPersonNo" msprop:Generator_ColumnPropNameInRow="cContactPersonNo" msprop:Generator_ColumnPropNameInTable="cContactPersonNoColumn" msprop:Generator_UserColumnName="cContactPersonNo" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactRelation" msprop:Generator_ColumnVarNameInTable="columncContactRelation" msprop:Generator_ColumnPropNameInRow="cContactRelation" msprop:Generator_ColumnPropNameInTable="cContactRelationColumn" msprop:Generator_UserColumnName="cContactRelation" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cContactEmail" msprop:Generator_ColumnVarNameInTable="columncContactEmail" msprop:Generator_ColumnPropNameInRow="cContactEmail" msprop:Generator_ColumnPropNameInTable="cContactEmailColumn" msprop:Generator_UserColumnName="cContactEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fHeight" msprop:Generator_ColumnVarNameInTable="columnfHeight" msprop:Generator_ColumnPropNameInRow="fHeight" msprop:Generator_ColumnPropNameInTable="fHeightColumn" msprop:Generator_UserColumnName="fHeight" type="xs:double" minOccurs="0" />
              <xs:element name="fWeight" msprop:Generator_ColumnVarNameInTable="columnfWeight" msprop:Generator_ColumnPropNameInRow="fWeight" msprop:Generator_ColumnPropNameInTable="fWeightColumn" msprop:Generator_UserColumnName="fWeight" type="xs:double" minOccurs="0" />
              <xs:element name="cBloodGroup" msprop:Generator_ColumnVarNameInTable="columncBloodGroup" msprop:Generator_ColumnPropNameInRow="cBloodGroup" msprop:Generator_ColumnPropNameInTable="cBloodGroupColumn" msprop:Generator_UserColumnName="cBloodGroup" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="fShoeSizeVN" msprop:Generator_ColumnVarNameInTable="columnfShoeSizeVN" msprop:Generator_ColumnPropNameInRow="fShoeSizeVN" msprop:Generator_ColumnPropNameInTable="fShoeSizeVNColumn" msprop:Generator_UserColumnName="fShoeSizeVN" type="xs:double" minOccurs="0" />
              <xs:element name="fShoeSizeJP" msprop:Generator_ColumnVarNameInTable="columnfShoeSizeJP" msprop:Generator_ColumnPropNameInRow="fShoeSizeJP" msprop:Generator_ColumnPropNameInTable="fShoeSizeJPColumn" msprop:Generator_UserColumnName="fShoeSizeJP" type="xs:double" minOccurs="0" />
              <xs:element name="fOverallSizeVN" msprop:Generator_ColumnVarNameInTable="columnfOverallSizeVN" msprop:Generator_ColumnPropNameInRow="fOverallSizeVN" msprop:Generator_ColumnPropNameInTable="fOverallSizeVNColumn" msprop:Generator_UserColumnName="fOverallSizeVN" type="xs:double" minOccurs="0" />
              <xs:element name="cOverallSizeJP" msprop:Generator_ColumnVarNameInTable="columncOverallSizeJP" msprop:Generator_ColumnPropNameInRow="cOverallSizeJP" msprop:Generator_ColumnPropNameInTable="cOverallSizeJPColumn" msprop:Generator_UserColumnName="cOverallSizeJP" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="10" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="bDeleted" msprop:Generator_ColumnVarNameInTable="columnbDeleted" msprop:Generator_ColumnPropNameInRow="bDeleted" msprop:Generator_ColumnPropNameInTable="bDeletedColumn" msprop:Generator_UserColumnName="bDeleted" type="xs:boolean" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblVessel" msprop:Generator_TableClassName="tblVesselDataTable" msprop:Generator_TableVarName="tabletblVessel" msprop:Generator_TablePropName="tblVessel" msprop:Generator_RowDeletingName="tblVesselRowDeleting" msprop:Generator_UserTableName="tblVessel" msprop:Generator_RowChangingName="tblVesselRowChanging" msprop:Generator_RowEvHandlerName="tblVesselRowChangeEventHandler" msprop:Generator_RowDeletedName="tblVesselRowDeleted" msprop:Generator_RowEvArgName="tblVesselRowChangeEvent" msprop:Generator_RowChangedName="tblVesselRowChanged" msprop:Generator_RowClassName="tblVesselRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nVesselId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" />
              <xs:element name="nEngineType" msprop:Generator_ColumnVarNameInTable="columnnEngineType" msprop:Generator_ColumnPropNameInRow="nEngineType" msprop:Generator_ColumnPropNameInTable="nEngineTypeColumn" msprop:Generator_UserColumnName="nEngineType" type="xs:int" minOccurs="0" />
              <xs:element name="nEngineMaker" msprop:Generator_ColumnVarNameInTable="columnnEngineMaker" msprop:Generator_ColumnPropNameInRow="nEngineMaker" msprop:Generator_ColumnPropNameInTable="nEngineMakerColumn" msprop:Generator_UserColumnName="nEngineMaker" type="xs:int" minOccurs="0" />
              <xs:element name="fHorsePower" msprop:Generator_ColumnVarNameInTable="columnfHorsePower" msprop:Generator_ColumnPropNameInRow="fHorsePower" msprop:Generator_ColumnPropNameInTable="fHorsePowerColumn" msprop:Generator_UserColumnName="fHorsePower" type="xs:double" minOccurs="0" />
              <xs:element name="cVesselName" msprop:Generator_ColumnVarNameInTable="columncVesselName" msprop:Generator_ColumnPropNameInRow="cVesselName" msprop:Generator_ColumnPropNameInTable="cVesselNameColumn" msprop:Generator_UserColumnName="cVesselName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cShortName" msprop:Generator_ColumnVarNameInTable="columncShortName" msprop:Generator_ColumnPropNameInRow="cShortName" msprop:Generator_ColumnPropNameInTable="cShortNameColumn" msprop:Generator_UserColumnName="cShortName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="30" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nGroupId" msprop:Generator_ColumnVarNameInTable="columnnGroupId" msprop:Generator_ColumnPropNameInRow="nGroupId" msprop:Generator_ColumnPropNameInTable="nGroupIdColumn" msprop:Generator_UserColumnName="nGroupId" type="xs:int" minOccurs="0" />
              <xs:element name="nFlagId" msprop:Generator_ColumnVarNameInTable="columnnFlagId" msprop:Generator_ColumnPropNameInRow="nFlagId" msprop:Generator_ColumnPropNameInTable="nFlagIdColumn" msprop:Generator_UserColumnName="nFlagId" type="xs:int" minOccurs="0" />
              <xs:element name="nVesselTypeId" msprop:Generator_ColumnVarNameInTable="columnnVesselTypeId" msprop:Generator_ColumnPropNameInRow="nVesselTypeId" msprop:Generator_ColumnPropNameInTable="nVesselTypeIdColumn" msprop:Generator_UserColumnName="nVesselTypeId" type="xs:int" minOccurs="0" />
              <xs:element name="fGRT" msprop:Generator_ColumnVarNameInTable="columnfGRT" msprop:Generator_ColumnPropNameInRow="fGRT" msprop:Generator_ColumnPropNameInTable="fGRTColumn" msprop:Generator_UserColumnName="fGRT" type="xs:double" minOccurs="0" />
              <xs:element name="cTradeArea" msprop:Generator_ColumnVarNameInTable="columncTradeArea" msprop:Generator_ColumnPropNameInRow="cTradeArea" msprop:Generator_ColumnPropNameInTable="cTradeAreaColumn" msprop:Generator_UserColumnName="cTradeArea" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cImoNumber" msprop:Generator_ColumnVarNameInTable="columncImoNumber" msprop:Generator_ColumnPropNameInRow="cImoNumber" msprop:Generator_ColumnPropNameInTable="cImoNumberColumn" msprop:Generator_UserColumnName="cImoNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cPortOfRegistry" msprop:Generator_ColumnVarNameInTable="columncPortOfRegistry" msprop:Generator_ColumnPropNameInRow="cPortOfRegistry" msprop:Generator_ColumnPropNameInTable="cPortOfRegistryColumn" msprop:Generator_UserColumnName="cPortOfRegistry" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dYearBuilt" msprop:Generator_ColumnVarNameInTable="columndYearBuilt" msprop:Generator_ColumnPropNameInRow="dYearBuilt" msprop:Generator_ColumnPropNameInTable="dYearBuiltColumn" msprop:Generator_UserColumnName="dYearBuilt" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblImmigrationCrew" msprop:Generator_TableClassName="tblImmigrationCrewDataTable" msprop:Generator_TableVarName="tabletblImmigrationCrew" msprop:Generator_TablePropName="tblImmigrationCrew" msprop:Generator_RowDeletingName="tblImmigrationCrewRowDeleting" msprop:Generator_UserTableName="tblImmigrationCrew" msprop:Generator_RowChangingName="tblImmigrationCrewRowChanging" msprop:Generator_RowEvHandlerName="tblImmigrationCrewRowChangeEventHandler" msprop:Generator_RowDeletedName="tblImmigrationCrewRowDeleted" msprop:Generator_RowEvArgName="tblImmigrationCrewRowChangeEvent" msprop:Generator_RowChangedName="tblImmigrationCrewRowChanged" msprop:Generator_RowClassName="tblImmigrationCrewRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nImmigrationCrewId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnImmigrationCrewId" msprop:Generator_ColumnPropNameInRow="nImmigrationCrewId" msprop:Generator_ColumnPropNameInTable="nImmigrationCrewIdColumn" msprop:Generator_UserColumnName="nImmigrationCrewId" type="xs:int" />
              <xs:element name="nImmigrationId" msprop:Generator_ColumnVarNameInTable="columnnImmigrationId" msprop:Generator_ColumnPropNameInRow="nImmigrationId" msprop:Generator_ColumnPropNameInTable="nImmigrationIdColumn" msprop:Generator_UserColumnName="nImmigrationId" type="xs:int" minOccurs="0" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cIssuedBy" msprop:Generator_ColumnVarNameInTable="columncIssuedBy" msprop:Generator_ColumnPropNameInRow="cIssuedBy" msprop:Generator_ColumnPropNameInTable="cIssuedByColumn" msprop:Generator_UserColumnName="cIssuedBy" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cNumber" msprop:Generator_ColumnVarNameInTable="columncNumber" msprop:Generator_ColumnPropNameInRow="cNumber" msprop:Generator_ColumnPropNameInTable="cNumberColumn" msprop:Generator_UserColumnName="cNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="2147483647" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dDateOfIssued" msprop:Generator_ColumnVarNameInTable="columndDateOfIssued" msprop:Generator_ColumnPropNameInRow="dDateOfIssued" msprop:Generator_ColumnPropNameInTable="dDateOfIssuedColumn" msprop:Generator_UserColumnName="dDateOfIssued" type="xs:dateTime" minOccurs="0" />
              <xs:element name="dDateOfExpiry" msprop:Generator_ColumnVarNameInTable="columndDateOfExpiry" msprop:Generator_ColumnPropNameInRow="dDateOfExpiry" msprop:Generator_ColumnPropNameInTable="dDateOfExpiryColumn" msprop:Generator_UserColumnName="dDateOfExpiry" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblImmigrationDoc" msprop:Generator_TableClassName="tblImmigrationDocDataTable" msprop:Generator_TableVarName="tabletblImmigrationDoc" msprop:Generator_TablePropName="tblImmigrationDoc" msprop:Generator_RowDeletingName="tblImmigrationDocRowDeleting" msprop:Generator_UserTableName="tblImmigrationDoc" msprop:Generator_RowChangingName="tblImmigrationDocRowChanging" msprop:Generator_RowEvHandlerName="tblImmigrationDocRowChangeEventHandler" msprop:Generator_RowDeletedName="tblImmigrationDocRowDeleted" msprop:Generator_RowEvArgName="tblImmigrationDocRowChangeEvent" msprop:Generator_RowChangedName="tblImmigrationDocRowChanged" msprop:Generator_RowClassName="tblImmigrationDocRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nImmigrationId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnImmigrationId" msprop:Generator_ColumnPropNameInRow="nImmigrationId" msprop:Generator_ColumnPropNameInTable="nImmigrationIdColumn" msprop:Generator_UserColumnName="nImmigrationId" type="xs:int" />
              <xs:element name="cDocName" msprop:Generator_ColumnVarNameInTable="columncDocName" msprop:Generator_ColumnPropNameInRow="cDocName" msprop:Generator_ColumnPropNameInTable="cDocNameColumn" msprop:Generator_UserColumnName="cDocName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDocDescription" msprop:Generator_ColumnVarNameInTable="columncDocDescription" msprop:Generator_ColumnPropNameInRow="cDocDescription" msprop:Generator_ColumnPropNameInTable="cDocDescriptionColumn" msprop:Generator_UserColumnName="cDocDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblEmployer" msprop:Generator_TableClassName="tblEmployerDataTable" msprop:Generator_TableVarName="tabletblEmployer" msprop:Generator_TablePropName="tblEmployer" msprop:Generator_RowDeletingName="tblEmployerRowDeleting" msprop:Generator_UserTableName="tblEmployer" msprop:Generator_RowChangingName="tblEmployerRowChanging" msprop:Generator_RowEvHandlerName="tblEmployerRowChangeEventHandler" msprop:Generator_RowDeletedName="tblEmployerRowDeleted" msprop:Generator_RowEvArgName="tblEmployerRowChangeEvent" msprop:Generator_RowChangedName="tblEmployerRowChanged" msprop:Generator_RowClassName="tblEmployerRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nEmployerId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnEmployerId" msprop:Generator_ColumnPropNameInRow="nEmployerId" msprop:Generator_ColumnPropNameInTable="nEmployerIdColumn" msprop:Generator_UserColumnName="nEmployerId" type="xs:int" />
              <xs:element name="cEmployerName" msprop:Generator_ColumnVarNameInTable="columncEmployerName" msprop:Generator_ColumnPropNameInRow="cEmployerName" msprop:Generator_ColumnPropNameInTable="cEmployerNameColumn" msprop:Generator_UserColumnName="cEmployerName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cAddresss" msprop:Generator_ColumnVarNameInTable="columncAddresss" msprop:Generator_ColumnPropNameInRow="cAddresss" msprop:Generator_ColumnPropNameInTable="cAddresssColumn" msprop:Generator_UserColumnName="cAddresss" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cDescription" msprop:Generator_ColumnVarNameInTable="columncDescription" msprop:Generator_ColumnPropNameInRow="cDescription" msprop:Generator_ColumnPropNameInTable="cDescriptionColumn" msprop:Generator_UserColumnName="cDescription" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblcontractList" msprop:Generator_TableClassName="tblcontractListDataTable" msprop:Generator_TableVarName="tabletblcontractList" msprop:Generator_TablePropName="tblcontractList" msprop:Generator_RowDeletingName="tblcontractListRowDeleting" msprop:Generator_UserTableName="tblcontractList" msprop:Generator_RowChangingName="tblcontractListRowChanging" msprop:Generator_RowEvHandlerName="tblcontractListRowChangeEventHandler" msprop:Generator_RowDeletedName="tblcontractListRowDeleted" msprop:Generator_RowEvArgName="tblcontractListRowChangeEvent" msprop:Generator_RowChangedName="tblcontractListRowChanged" msprop:Generator_RowClassName="tblcontractListRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="nContractId" msdata:ReadOnly="true" msdata:AutoIncrement="true" msdata:AutoIncrementSeed="-1" msdata:AutoIncrementStep="-1" msprop:Generator_ColumnVarNameInTable="columnnContractId" msprop:Generator_ColumnPropNameInRow="nContractId" msprop:Generator_ColumnPropNameInTable="nContractIdColumn" msprop:Generator_UserColumnName="nContractId" type="xs:int" />
              <xs:element name="nCrewId" msprop:Generator_ColumnVarNameInTable="columnnCrewId" msprop:Generator_ColumnPropNameInRow="nCrewId" msprop:Generator_ColumnPropNameInTable="nCrewIdColumn" msprop:Generator_UserColumnName="nCrewId" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="nEmployerId" msprop:Generator_ColumnVarNameInTable="columnnEmployerId" msprop:Generator_ColumnPropNameInRow="nEmployerId" msprop:Generator_ColumnPropNameInTable="nEmployerIdColumn" msprop:Generator_UserColumnName="nEmployerId" type="xs:int" minOccurs="0" />
              <xs:element name="nVesselId" msprop:Generator_ColumnVarNameInTable="columnnVesselId" msprop:Generator_ColumnPropNameInRow="nVesselId" msprop:Generator_ColumnPropNameInTable="nVesselIdColumn" msprop:Generator_UserColumnName="nVesselId" type="xs:int" minOccurs="0" />
              <xs:element name="dContractDate" msprop:Generator_ColumnVarNameInTable="columndContractDate" msprop:Generator_ColumnPropNameInRow="dContractDate" msprop:Generator_ColumnPropNameInTable="dContractDateColumn" msprop:Generator_UserColumnName="dContractDate" type="xs:dateTime" minOccurs="0" />
              <xs:element name="PeriodOfEmployment" msprop:Generator_ColumnVarNameInTable="columnPeriodOfEmployment" msprop:Generator_ColumnPropNameInRow="PeriodOfEmployment" msprop:Generator_ColumnPropNameInTable="PeriodOfEmploymentColumn" msprop:Generator_UserColumnName="PeriodOfEmployment" type="xs:double" minOccurs="0" />
              <xs:element name="cStatus" msprop:Generator_ColumnVarNameInTable="columncStatus" msprop:Generator_ColumnPropNameInRow="cStatus" msprop:Generator_ColumnPropNameInTable="cStatusColumn" msprop:Generator_UserColumnName="cStatus" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="cRankName" msprop:Generator_ColumnVarNameInTable="columncRankName" msprop:Generator_ColumnPropNameInRow="cRankName" msprop:Generator_ColumnPropNameInTable="cRankNameColumn" msprop:Generator_UserColumnName="cRankName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="200" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblContract" />
      <xs:field xpath="mstns:nContractId" />
    </xs:unique>
    <xs:unique name="tblCrew_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblCrew" />
      <xs:field xpath="mstns:nCrewId" />
    </xs:unique>
    <xs:unique name="tblVessel_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblVessel" />
      <xs:field xpath="mstns:nVesselId" />
    </xs:unique>
    <xs:unique name="tblImmigrationCrew_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblImmigrationCrew" />
      <xs:field xpath="mstns:nImmigrationCrewId" />
    </xs:unique>
    <xs:unique name="tblImmigrationDoc_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblImmigrationDoc" />
      <xs:field xpath="mstns:nImmigrationId" />
    </xs:unique>
    <xs:unique name="tblEmployer_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblEmployer" />
      <xs:field xpath="mstns:nEmployerId" />
    </xs:unique>
    <xs:unique name="tblcontractList_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblcontractList" />
      <xs:field xpath="mstns:nContractId" />
    </xs:unique>
  </xs:element>
  <xs:annotation>
    <xs:appinfo>
      <msdata:Relationship name="FK_tblContract_tblCrew" msdata:parent="tblCrew" msdata:child="tblContract" msdata:parentkey="nCrewId" msdata:childkey="nCrewId" msprop:Generator_UserChildTable="tblContract" msprop:Generator_ChildPropName="GettblContractRows" msprop:Generator_ParentPropName="tblCrewRow" msprop:Generator_UserRelationName="FK_tblContract_tblCrew" msprop:Generator_RelationVarName="relationFK_tblContract_tblCrew" msprop:Generator_UserParentTable="tblCrew" />
      <msdata:Relationship name="FK_tblContract_tblVessel" msdata:parent="tblVessel" msdata:child="tblContract" msdata:parentkey="nVesselId" msdata:childkey="nVesselId" msprop:Generator_UserChildTable="tblContract" msprop:Generator_ChildPropName="GettblContractRows" msprop:Generator_ParentPropName="tblVesselRow" msprop:Generator_UserRelationName="FK_tblContract_tblVessel" msprop:Generator_RelationVarName="relationFK_tblContract_tblVessel" msprop:Generator_UserParentTable="tblVessel" />
      <msdata:Relationship name="FK_tblImmigrationCrew_tblImmigrationDoc" msdata:parent="tblImmigrationDoc" msdata:child="tblImmigrationCrew" msdata:parentkey="nImmigrationId" msdata:childkey="nImmigrationId" msprop:Generator_UserChildTable="tblImmigrationCrew" msprop:Generator_ChildPropName="GettblImmigrationCrewRows" msprop:Generator_ParentPropName="tblImmigrationDocRow" msprop:Generator_UserRelationName="FK_tblImmigrationCrew_tblImmigrationDoc" msprop:Generator_RelationVarName="relationFK_tblImmigrationCrew_tblImmigrationDoc" msprop:Generator_UserParentTable="tblImmigrationDoc" />
      <msdata:Relationship name="FK_tblImmigrationCrew_tblCrew" msdata:parent="tblCrew" msdata:child="tblImmigrationCrew" msdata:parentkey="nCrewId" msdata:childkey="nCrewId" msprop:Generator_UserChildTable="tblImmigrationCrew" msprop:Generator_ChildPropName="GettblImmigrationCrewRows" msprop:Generator_ParentPropName="tblCrewRow" msprop:Generator_UserRelationName="FK_tblImmigrationCrew_tblCrew" msprop:Generator_RelationVarName="relationFK_tblImmigrationCrew_tblCrew" msprop:Generator_UserParentTable="tblCrew" />
      <msdata:Relationship name="FK_tblContract_tblEmployer" msdata:parent="tblEmployer" msdata:child="tblContract" msdata:parentkey="nEmployerId" msdata:childkey="nEmployerId" msprop:Generator_UserChildTable="tblContract" msprop:Generator_ChildPropName="GettblContractRows" msprop:Generator_UserParentTable="tblEmployer" msprop:Generator_UserRelationName="FK_tblContract_tblEmployer" msprop:Generator_RelationVarName="relationFK_tblContract_tblEmployer" msprop:Generator_ParentPropName="tblEmployerRow" />
      <msdata:Relationship name="FK_tblAssignment_tblCrew" msdata:parent="tblCrew" msdata:child="tblcontractList" msdata:parentkey="nCrewId" msdata:childkey="nCrewId" msprop:Generator_UserChildTable="tblcontractList" msprop:Generator_ChildPropName="GettblcontractListRows" msprop:Generator_UserParentTable="tblCrew" msprop:Generator_UserRelationName="FK_tblAssignment_tblCrew" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblCrew" msprop:Generator_ParentPropName="tblCrewRow" />
      <msdata:Relationship name="FK_tblAssignment_tblVessel" msdata:parent="tblVessel" msdata:child="tblcontractList" msdata:parentkey="nVesselId" msdata:childkey="nVesselId" msprop:Generator_UserChildTable="tblcontractList" msprop:Generator_ChildPropName="GettblcontractListRows" msprop:Generator_UserParentTable="tblVessel" msprop:Generator_UserRelationName="FK_tblAssignment_tblVessel" msprop:Generator_RelationVarName="relationFK_tblAssignment_tblVessel" msprop:Generator_ParentPropName="tblVesselRow" />
    </xs:appinfo>
  </xs:annotation>
</xs:schema>